SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327512 LIMIT 1 [ RunTime:0.000833s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327512 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194120,450390,951375,1027018,898982,354478,796481,523470,822043,927505,111486,151181,1030148,597578,511411,307691,290293,409700,433955,733941,899799,772061,235203,633842,871497,340558,428535,40109,126258,835395,778689,333224,65956,892084,642000,382383,576796,981638,441381,185738,508725,160737,368628,836623,1013474,37304,34043,613502,243527,276044,1005592,27047,1000629,726575,534204,570747,982122,179909,492135,128611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]