SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505963 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505963 [ RunTime:0.002218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18580,81779,250797,699558,179707,730068,849495,815895,602781,11112,722595,472455,963077,767581,518684,306120,1034006,474670,877256,8191,1047483,928546,238293,306523,706047,582660,166696,356501,354039,342782,94255,604636,953443,704745,462881,301990,628720,426047,151749,992268,686031,386316,282381,705159,891119,975997,600108,533375,633107,669872,950368,94910,1032444,404298,39512,773805,789158,949462,48554,573080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]