SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297613 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297613 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484974,484845,819680,519203,416121,757683,832196,1015342,978721,566280,27201,250943,614787,799014,614597,501003,544955,479434,668522,571441,472082,745748,418854,53132,827926,824669,394938,845393,427694,93179,597739,715312,394611,884866,679728,975608,34583,805241,572921,981424,257263,661187,460626,592174,397963,960731,896,996660,865143,1028982,305803,287480,184584,972115,1036290,196446,56519,546537,263792,64752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]