SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 362003 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 362003 [ RunTime:0.003550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418470,465439,830379,666637,161630,812278,654341,352481,116048,305841,861480,641259,354450,206950,941187,13000,768726,635617,790421,592850,814369,1038209,128614,683479,517911,515348,785473,22014,98118,404611,403068,434666,1006632,265317,895337,997432,572180,720332,494030,967038,796501,224423,61187,994212,894600,61656,818721,387394,695528,912543,313395,664742,378665,549146,473124,125922,774401,92884,75892,456247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 362003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 362003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003180s ]