SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505559 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505559 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779270,896651,74854,678918,630691,78932,866828,818070,320736,1001490,633880,830249,953897,675256,304322,733482,687765,594519,147127,381022,17672,740235,1014309,495520,793666,1001362,445265,125236,2905,215818,880595,269225,576758,268418,939582,143654,553304,621096,347470,657450,850047,34364,501488,1001502,892006,999653,90811,583483,218366,241257,80232,251111,958872,751399,155475,143623,842777,833504,12204,968190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505559 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505559 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]