SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005896s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493861 LIMIT 1 [ RunTime:0.005915s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493861 [ RunTime:0.008330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154779,938938,855478,111380,761424,349753,990534,357592,809566,597563,668311,393480,703763,797459,211459,446229,439250,128472,1034392,64438,151883,89192,1012733,313518,685581,363193,484296,708333,427879,998671,440450,163256,15711,346543,933510,781054,593450,959081,328417,713292,36085,341771,640816,368341,1034540,701750,361709,267760,953744,541094,266476,464953,612605,830808,92745,863021,905277,943574,635751,334208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002391s ]