SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505802 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505802 [ RunTime:0.003159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672950,511714,285127,813250,512051,969888,301511,381848,722697,454103,741073,348257,171966,517178,56380,821103,475048,79727,896506,472809,997009,978956,957060,488570,671515,487604,326395,6449,120023,409321,411979,498607,1037546,572222,560008,617259,600465,1033524,71129,598636,223856,157471,20998,624043,476342,281975,1040646,831598,141423,481494,835518,649394,378265,130602,520837,501290,522707,350201,117513,554197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]