SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328914 LIMIT 1 [ RunTime:0.000631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328914 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942074,1011816,854620,745577,837684,377063,828067,429523,146744,597214,676006,164875,804244,568451,422669,683773,224322,167563,911614,1003847,887896,276764,1006321,881599,252167,757559,753743,923686,336688,400524,835459,567992,368841,877157,11710,203338,860267,335672,303035,711153,341999,93087,100556,664006,675962,814982,815813,433936,995769,642956,654413,839392,296994,485613,924420,551592,145000,150528,741962,681574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]