SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459473 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459473 [ RunTime:0.003456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599952,672265,964636,1040443,1041609,548334,762466,796647,469369,44937,773495,46531,426970,670825,272359,232637,427895,501673,740048,861726,669023,329594,118842,587388,488550,40007,249680,835167,499774,4504,406374,652186,856258,90663,987255,478516,479489,885562,264516,61164,178842,244952,1006561,498724,530687,358365,141592,421735,640694,128665,697879,480149,77358,730618,667614,41365,261913,945341,561386,480468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]