SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034896 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034896 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019974,800253,465328,777914,267323,894411,827199,974869,468632,733693,600633,73563,18602,736003,99653,786536,87436,287153,818633,503198,161201,249111,292189,772823,517960,850777,124697,800839,368745,394079,334172,303458,988900,939639,357589,760182,564070,635846,563234,474545,582538,753123,90792,855937,926341,120380,420039,990297,640145,173905,963584,25646,448531,631181,204626,566793,35363,673120,417023,31230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]