SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 235438 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 235438 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100084,942443,724652,606098,1016882,91298,188694,160159,549854,777358,556463,820265,668660,417937,117310,213398,4367,790662,870241,141276,534242,909272,51931,87153,460158,954017,152763,54443,682178,77795,768193,43564,259590,195007,430044,541408,17854,766433,650383,2396,191160,202925,819516,278263,970279,709365,298964,14834,565079,695860,40028,448747,747282,1028280,575695,340283,458663,724142,688061,1041947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 235438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 235438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]