SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299658 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299658 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352553,361920,88580,235442,753116,319089,473006,561052,454691,370360,1034567,523258,613077,432487,570081,276329,102772,125323,765924,743746,204052,185332,216824,875969,799427,465843,191963,151689,280735,344836,968608,200548,927577,1016916,253799,297999,692983,889849,937695,987623,982133,883969,177936,410284,950159,717630,829949,14927,168211,68271,430966,158851,22203,197755,644293,437227,107322,167151,342539,1037058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]