SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506476 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506476 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678893,962692,477103,772123,264707,691379,43879,298152,560492,19978,554749,1019343,680702,424751,1037784,10835,221483,22210,91199,1005248,800908,260697,1032544,924730,573873,562291,785887,968461,173270,157795,259105,420893,856234,242953,533193,421021,623447,747327,138344,1046293,492929,505099,494875,681528,524636,653185,382045,89297,94196,341933,150811,881166,1046676,275884,979307,967007,779813,499665,703555,328868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001166s ]