SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48102 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48102 [ RunTime:0.002589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488505,633069,388619,600645,793812,880757,11804,927029,118603,1033173,909927,623341,121194,647627,458724,476202,608117,512295,543351,676455,907111,647292,999616,882714,687501,138177,478107,91243,481076,227788,313112,50958,438733,477305,352513,740548,907063,445659,205960,922835,783905,868299,1032390,630953,591562,976427,1046867,374362,182485,1016516,884430,648340,909231,945000,803949,909881,288559,518230,941055,267675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]