SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802443 LIMIT 1 [ RunTime:0.001493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802443 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982978,692068,62216,779016,993709,596830,99156,130491,910438,588742,133491,178850,411694,438356,830101,650721,154172,296943,197319,114449,5483,339071,82228,83570,4624,495620,243581,831751,680787,547018,374879,1015572,781799,2803,665169,575730,1039239,92148,910717,627858,764511,63904,907472,737003,513534,503165,1023888,128170,906339,441294,286911,387373,562427,907897,938795,905782,133357,417524,622371,1008945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.040734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003002s ]