SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4176 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4176 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989887,877555,468319,1009514,786781,929103,1036236,984326,84957,157540,378591,1041542,938126,916233,91211,611471,591267,548566,16147,525539,455061,279694,160172,15218,639025,140366,951845,590990,616266,420757,47806,113413,174522,761133,81762,197764,829411,743721,984057,102264,75314,410845,511099,172535,163293,794829,1031563,52344,638266,43621,195217,873415,179841,438203,907141,892598,589428,890270,787998,494933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]