SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012412 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012412 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908080,697383,210246,856629,259499,985214,959790,876850,74845,672670,34261,203463,474049,1003422,840317,762156,290770,722163,1004680,461660,280501,313854,192457,470332,712415,447263,574735,738588,292998,807561,694089,216090,716196,944762,424458,160217,82418,88234,359633,410224,123936,653628,966336,982314,781415,87757,362604,886689,65590,956235,598648,482537,657376,511920,844410,52748,550502,63334,873000,112482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001845s ]