SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538310 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538310 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143681,344729,937725,354520,5367,46858,288149,256909,743262,576774,53769,747161,675298,439124,892937,779843,1009128,43994,146854,942737,130150,319304,930688,177045,391206,154416,397982,112208,899338,633334,185478,640238,529423,969546,153058,481488,483499,661075,725554,15860,899259,731161,693384,480860,449347,793302,323595,715831,863012,188729,272760,202415,109874,694799,118225,972741,150305,369336,374246,539665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]