SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438753 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438753 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13671,247034,924962,905245,807125,616866,49736,362372,610202,1048565,576311,150366,1026924,506935,303452,694436,293456,804496,486215,510216,467853,425417,8869,879264,441191,384928,959266,556525,16327,612700,995766,154064,558563,1009604,1012444,348244,105428,493913,101022,42418,498729,833012,712082,439627,713196,103506,263084,657870,1025211,686143,367193,405375,986702,649867,943949,219201,763779,346714,880181,197930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]