SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501026 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501026 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661983,733366,248188,458506,406977,211808,169031,380903,428305,653878,778255,796232,184685,489513,175562,29465,37821,63701,96112,490327,722767,22186,451032,967407,720474,669709,798578,260876,798298,665976,828978,498152,499126,710522,939772,420656,20668,653828,851594,375354,837121,346393,60941,391754,303846,591955,372681,373058,125062,423132,159229,524836,726894,179042,80573,723048,242354,442427,576283,947563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]