SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541656 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541656 [ RunTime:0.003155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592082,871978,570572,709427,402973,948590,796785,599402,165641,156628,371658,750931,647668,43268,789982,916559,589838,125756,172234,229354,974008,736218,681462,415624,112719,61906,345448,559478,242246,641449,675058,753783,676974,645055,788087,430522,963435,140064,987778,192898,135779,1019423,1018779,644552,939501,442378,225920,436285,669747,890125,529235,773647,712969,595490,630649,493872,429067,168675,291041,296839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]