SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533805 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533805 [ RunTime:0.001389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310584,554505,959789,324283,41903,1013002,867209,963907,871381,140107,1035411,961710,730154,31044,944385,645135,1005959,809905,1037360,825063,193065,312857,853065,148092,164310,652497,20323,612392,437161,672377,158251,1019612,312094,625582,834818,38210,372379,488456,143407,950139,151075,421980,447912,802960,956074,52026,703734,365789,353368,235243,235678,372053,410412,363140,236609,723739,837415,372647,790741,249215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]