SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536982 LIMIT 1 [ RunTime:0.000805s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536982 [ RunTime:0.003137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157030,244606,464542,673041,671376,171234,1035854,318816,123042,778310,1005165,836058,1033083,1006422,693685,544835,940271,478182,501259,775276,216510,479758,14583,262983,691828,308559,1022716,381703,176418,614579,376877,1019939,623153,910256,879731,863105,633465,1027832,487882,208504,726858,483155,231880,152169,969265,860791,266554,968752,368210,495938,830172,427832,944687,185066,297646,746732,475391,430369,222040,372955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]