SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425651 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425651 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149240,498146,633468,991082,837064,879790,807442,904241,436870,412838,136099,873733,896759,216603,564451,375823,601079,243908,725726,86987,20436,497335,295850,1012467,410008,895766,994670,831992,49009,158816,675296,386732,672429,851711,735893,241651,895919,902775,541654,257799,1026846,544923,481217,753385,248339,181378,828385,983003,37615,1034566,600443,683753,676920,288234,958213,1037522,248425,204913,28699,474922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]