SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292904 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292904 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980082,345626,843546,828464,1018139,532551,229017,957289,447889,520764,109878,150547,597726,610400,30106,47849,650117,10625,131581,807294,802437,620302,571213,249990,673736,913555,293248,411571,114594,580400,74007,813040,187420,88044,622850,518550,91691,468248,323065,364412,935254,1029768,272065,896676,718164,157612,1033477,660325,497453,84462,118931,19591,274016,704691,238096,73548,443543,695822,779673,970548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001035s ]