SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507958 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507958 [ RunTime:0.002301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60959,166322,221259,595535,354550,140704,562347,131484,783374,499356,937779,902124,614105,481308,528001,668293,840388,974120,201526,66996,466756,1007514,581955,904393,508085,748814,632636,304539,983342,472789,360199,633850,833328,193740,936878,471133,690618,852571,560880,334478,104482,255875,267382,658674,1003056,49204,690805,238787,882685,73441,380169,422639,525346,126862,1036335,421689,350509,411898,64776,23301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001003s ]