SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042299 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042299 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869243,669199,74657,305828,677798,751297,335202,924680,909596,1017199,442437,210775,372574,845169,391089,263064,479811,547594,1000952,810285,960808,207983,741826,226713,840530,646409,931772,307526,70552,172605,252014,880142,344989,448060,25066,116088,3080,403526,935565,311269,58962,510126,606305,616444,744935,398930,874929,77691,737625,363793,576671,848332,56921,9604,838066,297153,441939,654992,997637,484581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]