SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005162 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005162 [ RunTime:0.005603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293833,662829,180800,53876,438855,224091,132296,318519,525045,359034,19641,333041,636697,490991,626849,176119,187406,108603,515152,369264,867495,841367,275214,850165,511627,94427,411706,856168,350631,166639,600201,658027,390970,984190,718334,137738,820441,445618,624694,414827,731741,201472,374715,227483,641255,42968,43620,233173,697246,267688,782018,539635,415145,923783,225788,805771,1956,839000,182970,922410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005162 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005162 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]